package com.itzol.javablog.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itzol.javablog.entity.Post;
import com.itzol.javablog.entity.Postvo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface Postmapper extends BaseMapper<Post> {
    @Select("select p.id id,p.title,p.content,c.name categoryname from post p,category c where p.categoryid=c.id")
    List<Postvo> postvo();
}
